


ALTER     proc sp_release_selected_lineItems


@lineItem_id int, @user_id varchar(20) , @user_name varchar(50), @user_group varchar(50)
as 

declare @salesOrder_id int

select @salesOrder_id = (SELECT SalesOrder_Id FROM Customer_Open_Order_LineItem
	WHERE LineItem_ID = @lineItem_id)

/*
 * Execute proc for holding the lineItem, 0 for hold
 */
exec sp_approve_lineItem @lineItem_id, @salesOrder_id, @user_id, @user_name,
	@user_group, 1




